Generating subtotal reports direct from SQL

I'm hoping there's a real easy way of doing this that I'm just missing:

Given a Select statement such as:

Select ID, code, amount from foo where code < 10;

that gives me a table like this:

ID    code        amount
_____________________________________
1    4        20
2    3        10
3    4        15
4    2        10
5    3        9
6    3        8

I want to generate a report table like the following (group by code):

ID    code        amount
_____________________________________
4    2        10
    2        10
2    3        10
5    3        9
6    3        8
    3        27
1    4        20
3    4        15
    4        35
            72

Such that the final table has additional subtotal rows with the
aggregate sum of the amounts.  I'm thinking I can generate two tables
and merge them, but is there an easier way using a fancy Select
statement?

-Owen